﻿CREATE PROCEDURE [dbo].[proc_AppMenu_GetList_ParentId]
	(
		@ParentId int
	)
AS
	Select 
	MenuId,
	ParentId,
	Title,
	CId,
	AId,
	isnull((Select CName From AppController Where Id=AppMenu.CId),'') As ControllerName,
	isnull((Select AName From AppAction Where Id=AppMenu.AId),'') As ActionName,
	CreateTime,
	Sort
	From AppMenu Where ParentId=@ParentId Order by Sort
	RETURN
